{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-12T09:24:11.622746Z",
     "start_time": "2019-07-12T09:24:11.100145Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ACCOUNT_ID</th>\n",
       "      <th>USER_TYPE</th>\n",
       "      <th>ACCEPT_AREA_NAME</th>\n",
       "      <th>CREDIT_BY</th>\n",
       "      <th>COMPLETE_TIME</th>\n",
       "      <th>SEASON4</th>\n",
       "      <th>STATUS4</th>\n",
       "      <th>REPAY_TIME4</th>\n",
       "      <th>SEASON5</th>\n",
       "      <th>STATUS5</th>\n",
       "      <th>REPAY_TIME5</th>\n",
       "      <th>SEASON6</th>\n",
       "      <th>STATUS6</th>\n",
       "      <th>REPAY_TIME6</th>\n",
       "      <th>SEASON7</th>\n",
       "      <th>STATUS7</th>\n",
       "      <th>REPAY_TIME7</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20180228121809771224</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2019/5/20 10:45:34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/6 4:53:19</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/6 15:28:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20190320095140191706</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/20 10:32:22</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:34</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/3 9:00:46</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:34</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/4 10:22:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20190320114054198506</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/20 11:46:37</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/1 8:53:47</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/2 9:02:35</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/1 8:58:42</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/1 9:01:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20190320172256219125</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/20 17:30:55</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:36</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:34</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:36</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20190320153449211918</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/20 15:57:29</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:45:39</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:34</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:36</td>\n",
       "      <td>201907</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>20190321114805236259</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/21 11:59:57</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:40</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:39</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/7 21:35:30</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 9:43:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20190321151236247571</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/21 17:57:35</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/12 10:53:45</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/5 9:43:34</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/5 8:48:14</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 8:46:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>20190322123744277012</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/22 13:17:53</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:45:50</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/4 16:05:22</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/4 9:26:06</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/4 10:49:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>20190322122205275956</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/22 12:40:04</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:46</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:46</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:50</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>20190322134142280420</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/22 13:58:37</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/5 14:40:43</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/6 9:20:11</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/6 9:05:07</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/6 9:09:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>20190322151555286867</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/22 15:58:13</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/12 20:27:36</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/12 9:15:32</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:51</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/4 9:16:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>20190322154043288857</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/22 17:59:35</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/5 12:32:11</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:48</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:52</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>20190322114222273485</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/24 18:52:36</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:45:50</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:48</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:52</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>20190322100903266960</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 12:27:22</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:47</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:47</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:51</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>20190322215547303213</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/22 22:18:47</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/12 8:59:23</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:47</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:52</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/7 8:47:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>20190323114543315984</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 12:09:04</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:52</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:56</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/17 11:39:26</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/11 8:30:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20190323103052309538</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 12:03:12</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:45:59</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:53</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/7 21:10:13</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 9:34:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20190323140904326080</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 14:36:41</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:45:58</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:54</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>OPEN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20190323162520337733</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 16:54:17</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:54</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:56</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:59</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20190323210504351004</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 21:16:44</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 20:47:31</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:55</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:30:59</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20190323105910311998</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/24 15:42:57</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:53</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:55</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:31:00</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>20190323183715346538</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/23 18:54:14</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:45:56</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:46:55</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/9 20:23:59</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 20:17:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>20190324150450376036</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/24 15:23:15</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/6 8:36:33</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 20:19:13</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:31:10</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>20190324151755377209</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/24 15:27:08</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:35:59</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:47:02</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:31:08</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>20190324220647394904</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/25 13:58:44</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/5 13:09:36</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/5 9:08:19</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/5 9:35:40</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>20190325100935398241</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/25 10:45:51</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/5 12:48:05</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:47:14</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:31:20</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 8:48:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20190325114233404209</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/25 11:55:37</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/1 9:16:14</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/2 9:35:04</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/1 9:23:53</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/1 9:28:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20190325125027407397</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/25 13:08:41</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/5 13:00:24</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/5 9:05:18</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/5 9:30:16</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 8:51:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>20190325121243405835</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/25 12:33:36</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/8 11:36:07</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/8 9:47:11</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/8 11:31:18</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 10:17:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>20190325111854402377</td>\n",
       "      <td>2</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>DUMIAO</td>\n",
       "      <td>2019/3/25 11:51:05</td>\n",
       "      <td>201904.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/4/1 8:31:02</td>\n",
       "      <td>201905.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/5/6 9:19:02</td>\n",
       "      <td>201906.0</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/6 9:00:21</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/6 9:03:13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77392</th>\n",
       "      <td>20190629183405114835</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/29 19:17:34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/6/29 19:38:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77393</th>\n",
       "      <td>20190630105130130511</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 11:03:31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 7:39:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77394</th>\n",
       "      <td>20190630103104128527</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 11:10:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77395</th>\n",
       "      <td>20190630110226131542</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 11:34:25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77396</th>\n",
       "      <td>20190630122830138701</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 13:02:07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77397</th>\n",
       "      <td>20190630100011126051</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 10:25:06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77398</th>\n",
       "      <td>20190630101844127376</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 10:53:04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77399</th>\n",
       "      <td>20190630084849122133</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 9:06:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/7 9:08:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77400</th>\n",
       "      <td>20190630103307128835</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 11:03:18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77401</th>\n",
       "      <td>20190630102844128327</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 10:40:08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77402</th>\n",
       "      <td>20190630093504124110</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 9:54:43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 7:59:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77403</th>\n",
       "      <td>20190630125107140416</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 13:05:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/6 9:00:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77404</th>\n",
       "      <td>20190630153810152829</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 16:09:38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77405</th>\n",
       "      <td>20190630174542164025</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 17:49:01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 8:03:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77406</th>\n",
       "      <td>20190630204958172253</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 21:20:58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 21:22:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77407</th>\n",
       "      <td>20190630134901144058</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 14:16:37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/9 9:32:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77408</th>\n",
       "      <td>20190630210842172839</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 21:25:16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77409</th>\n",
       "      <td>20190630181814166294</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 18:37:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77410</th>\n",
       "      <td>20190630155737154358</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 16:01:06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 8:01:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77411</th>\n",
       "      <td>20190630131037141362</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 13:46:51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 10:13:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77412</th>\n",
       "      <td>20190630134518143808</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 14:46:29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/5 10:28:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77413</th>\n",
       "      <td>20190630160701155183</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 16:11:58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77414</th>\n",
       "      <td>20190630161101155562</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 16:19:48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77415</th>\n",
       "      <td>20190630174751164219</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 18:10:22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77416</th>\n",
       "      <td>20190630142126146266</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 14:54:23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77417</th>\n",
       "      <td>20190630140459145097</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 14:17:29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77418</th>\n",
       "      <td>20190630153005151929</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 16:06:12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77419</th>\n",
       "      <td>20190630185950168335</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 19:09:11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/3 22:06:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77420</th>\n",
       "      <td>20190630200008170899</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 20:12:05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77421</th>\n",
       "      <td>20190630183525167248</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>2019/6/30 21:46:10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201907</td>\n",
       "      <td>CLEAR</td>\n",
       "      <td>2019/7/8 12:16:34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>77422 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 ACCOUNT_ID  USER_TYPE ACCEPT_AREA_NAME     CREDIT_BY  \\\n",
       "0      20180228121809771224          1              广东省       ZHONGAN   \n",
       "1      20190320095140191706          2              重庆市        DUMIAO   \n",
       "2      20190320114054198506          2              重庆市        DUMIAO   \n",
       "3      20190320172256219125          2              重庆市        DUMIAO   \n",
       "4      20190320153449211918          2              重庆市        DUMIAO   \n",
       "5      20190321114805236259          2              重庆市        DUMIAO   \n",
       "6      20190321151236247571          2              重庆市        DUMIAO   \n",
       "7      20190322123744277012          2              重庆市        DUMIAO   \n",
       "8      20190322122205275956          2              重庆市        DUMIAO   \n",
       "9      20190322134142280420          2              重庆市        DUMIAO   \n",
       "10     20190322151555286867          2              重庆市        DUMIAO   \n",
       "11     20190322154043288857          2              重庆市        DUMIAO   \n",
       "12     20190322114222273485          2              重庆市        DUMIAO   \n",
       "13     20190322100903266960          2              重庆市        DUMIAO   \n",
       "14     20190322215547303213          2              重庆市        DUMIAO   \n",
       "15     20190323114543315984          2              重庆市        DUMIAO   \n",
       "16     20190323103052309538          2              重庆市        DUMIAO   \n",
       "17     20190323140904326080          2              重庆市        DUMIAO   \n",
       "18     20190323162520337733          2              重庆市        DUMIAO   \n",
       "19     20190323210504351004          2              重庆市        DUMIAO   \n",
       "20     20190323105910311998          2              重庆市        DUMIAO   \n",
       "21     20190323183715346538          2              重庆市        DUMIAO   \n",
       "22     20190324150450376036          2              重庆市        DUMIAO   \n",
       "23     20190324151755377209          2              重庆市        DUMIAO   \n",
       "24     20190324220647394904          2              重庆市        DUMIAO   \n",
       "25     20190325100935398241          2              重庆市        DUMIAO   \n",
       "26     20190325114233404209          2              重庆市        DUMIAO   \n",
       "27     20190325125027407397          2              重庆市        DUMIAO   \n",
       "28     20190325121243405835          2              重庆市        DUMIAO   \n",
       "29     20190325111854402377          2              重庆市        DUMIAO   \n",
       "...                     ...        ...              ...           ...   \n",
       "77392  20190629183405114835          1              广东省  ZIZHUSHOUXIN   \n",
       "77393  20190630105130130511          1              江苏省  ZIZHUSHOUXIN   \n",
       "77394  20190630103104128527          1              广东省  ZIZHUSHOUXIN   \n",
       "77395  20190630110226131542          1              广东省  ZIZHUSHOUXIN   \n",
       "77396  20190630122830138701          1              重庆市  ZIZHUSHOUXIN   \n",
       "77397  20190630100011126051          1              广东省  ZIZHUSHOUXIN   \n",
       "77398  20190630101844127376          1              广东省  ZIZHUSHOUXIN   \n",
       "77399  20190630084849122133          1              重庆市  ZIZHUSHOUXIN   \n",
       "77400  20190630103307128835          1              广东省  ZIZHUSHOUXIN   \n",
       "77401  20190630102844128327          1              广东省  ZIZHUSHOUXIN   \n",
       "77402  20190630093504124110          1              江苏省  ZIZHUSHOUXIN   \n",
       "77403  20190630125107140416          1              重庆市  ZIZHUSHOUXIN   \n",
       "77404  20190630153810152829          1              广东省  ZIZHUSHOUXIN   \n",
       "77405  20190630174542164025          1              江苏省  ZIZHUSHOUXIN   \n",
       "77406  20190630204958172253          1              江苏省  ZIZHUSHOUXIN   \n",
       "77407  20190630134901144058          1              广东省  ZIZHUSHOUXIN   \n",
       "77408  20190630210842172839          1              广东省  ZIZHUSHOUXIN   \n",
       "77409  20190630181814166294          1              江苏省  ZIZHUSHOUXIN   \n",
       "77410  20190630155737154358          1              江苏省  ZIZHUSHOUXIN   \n",
       "77411  20190630131037141362          1              江苏省  ZIZHUSHOUXIN   \n",
       "77412  20190630134518143808          1              重庆市  ZIZHUSHOUXIN   \n",
       "77413  20190630160701155183          1              重庆市  ZIZHUSHOUXIN   \n",
       "77414  20190630161101155562          1              江苏省  ZIZHUSHOUXIN   \n",
       "77415  20190630174751164219          1              广东省  ZIZHUSHOUXIN   \n",
       "77416  20190630142126146266          1              广东省  ZIZHUSHOUXIN   \n",
       "77417  20190630140459145097          1              重庆市  ZIZHUSHOUXIN   \n",
       "77418  20190630153005151929          1              重庆市  ZIZHUSHOUXIN   \n",
       "77419  20190630185950168335          1              江苏省  ZIZHUSHOUXIN   \n",
       "77420  20190630200008170899          1              广东省  ZIZHUSHOUXIN   \n",
       "77421  20190630183525167248          1              重庆市  ZIZHUSHOUXIN   \n",
       "\n",
       "            COMPLETE_TIME   SEASON4 STATUS4         REPAY_TIME4   SEASON5  \\\n",
       "0      2019/5/20 10:45:34       NaN     NaN                 NaN       NaN   \n",
       "1      2019/3/20 10:32:22  201904.0   CLEAR   2019/4/8 11:35:34  201905.0   \n",
       "2      2019/3/20 11:46:37  201904.0   CLEAR    2019/4/1 8:53:47  201905.0   \n",
       "3      2019/3/20 17:30:55  201904.0   CLEAR   2019/4/8 11:35:36  201905.0   \n",
       "4      2019/3/20 15:57:29  201904.0   CLEAR   2019/4/8 11:45:39  201905.0   \n",
       "5      2019/3/21 11:59:57  201904.0   CLEAR   2019/4/8 11:35:40  201905.0   \n",
       "6      2019/3/21 17:57:35  201904.0   CLEAR  2019/4/12 10:53:45  201905.0   \n",
       "7      2019/3/22 13:17:53  201904.0   CLEAR   2019/4/8 11:45:50  201905.0   \n",
       "8      2019/3/22 12:40:04  201904.0   CLEAR   2019/4/8 11:35:46  201905.0   \n",
       "9      2019/3/22 13:58:37  201904.0   CLEAR   2019/4/5 14:40:43  201905.0   \n",
       "10     2019/3/22 15:58:13  201904.0   CLEAR  2019/4/12 20:27:36  201905.0   \n",
       "11     2019/3/22 17:59:35  201904.0   CLEAR   2019/4/5 12:32:11  201905.0   \n",
       "12     2019/3/24 18:52:36  201904.0   CLEAR   2019/4/8 11:45:50  201905.0   \n",
       "13     2019/3/23 12:27:22  201904.0   CLEAR   2019/4/8 11:35:47  201905.0   \n",
       "14     2019/3/22 22:18:47  201904.0   CLEAR   2019/4/12 8:59:23  201905.0   \n",
       "15     2019/3/23 12:09:04  201904.0   CLEAR   2019/4/8 11:35:52  201905.0   \n",
       "16     2019/3/23 12:03:12  201904.0   CLEAR   2019/4/8 11:45:59  201905.0   \n",
       "17     2019/3/23 14:36:41  201904.0   CLEAR   2019/4/8 11:45:58  201905.0   \n",
       "18     2019/3/23 16:54:17  201904.0   CLEAR   2019/4/8 11:35:54  201905.0   \n",
       "19     2019/3/23 21:16:44  201904.0   CLEAR   2019/4/8 20:47:31  201905.0   \n",
       "20     2019/3/24 15:42:57  201904.0   CLEAR   2019/4/8 11:35:53  201905.0   \n",
       "21     2019/3/23 18:54:14  201904.0   CLEAR   2019/4/8 11:45:56  201905.0   \n",
       "22     2019/3/24 15:23:15  201904.0   CLEAR    2019/4/6 8:36:33  201905.0   \n",
       "23     2019/3/24 15:27:08  201904.0   CLEAR   2019/4/8 11:35:59  201905.0   \n",
       "24     2019/3/25 13:58:44  201904.0   CLEAR   2019/4/5 13:09:36  201905.0   \n",
       "25     2019/3/25 10:45:51  201904.0   CLEAR   2019/4/5 12:48:05  201905.0   \n",
       "26     2019/3/25 11:55:37  201904.0   CLEAR    2019/4/1 9:16:14  201905.0   \n",
       "27     2019/3/25 13:08:41  201904.0   CLEAR   2019/4/5 13:00:24  201905.0   \n",
       "28     2019/3/25 12:33:36  201904.0   CLEAR   2019/4/8 11:36:07  201905.0   \n",
       "29     2019/3/25 11:51:05  201904.0   CLEAR    2019/4/1 8:31:02  201905.0   \n",
       "...                   ...       ...     ...                 ...       ...   \n",
       "77392  2019/6/29 19:17:34       NaN     NaN                 NaN       NaN   \n",
       "77393  2019/6/30 11:03:31       NaN     NaN                 NaN       NaN   \n",
       "77394  2019/6/30 11:10:00       NaN     NaN                 NaN       NaN   \n",
       "77395  2019/6/30 11:34:25       NaN     NaN                 NaN       NaN   \n",
       "77396  2019/6/30 13:02:07       NaN     NaN                 NaN       NaN   \n",
       "77397  2019/6/30 10:25:06       NaN     NaN                 NaN       NaN   \n",
       "77398  2019/6/30 10:53:04       NaN     NaN                 NaN       NaN   \n",
       "77399   2019/6/30 9:06:00       NaN     NaN                 NaN       NaN   \n",
       "77400  2019/6/30 11:03:18       NaN     NaN                 NaN       NaN   \n",
       "77401  2019/6/30 10:40:08       NaN     NaN                 NaN       NaN   \n",
       "77402   2019/6/30 9:54:43       NaN     NaN                 NaN       NaN   \n",
       "77403  2019/6/30 13:05:00       NaN     NaN                 NaN       NaN   \n",
       "77404  2019/6/30 16:09:38       NaN     NaN                 NaN       NaN   \n",
       "77405  2019/6/30 17:49:01       NaN     NaN                 NaN       NaN   \n",
       "77406  2019/6/30 21:20:58       NaN     NaN                 NaN       NaN   \n",
       "77407  2019/6/30 14:16:37       NaN     NaN                 NaN       NaN   \n",
       "77408  2019/6/30 21:25:16       NaN     NaN                 NaN       NaN   \n",
       "77409  2019/6/30 18:37:35       NaN     NaN                 NaN       NaN   \n",
       "77410  2019/6/30 16:01:06       NaN     NaN                 NaN       NaN   \n",
       "77411  2019/6/30 13:46:51       NaN     NaN                 NaN       NaN   \n",
       "77412  2019/6/30 14:46:29       NaN     NaN                 NaN       NaN   \n",
       "77413  2019/6/30 16:11:58       NaN     NaN                 NaN       NaN   \n",
       "77414  2019/6/30 16:19:48       NaN     NaN                 NaN       NaN   \n",
       "77415  2019/6/30 18:10:22       NaN     NaN                 NaN       NaN   \n",
       "77416  2019/6/30 14:54:23       NaN     NaN                 NaN       NaN   \n",
       "77417  2019/6/30 14:17:29       NaN     NaN                 NaN       NaN   \n",
       "77418  2019/6/30 16:06:12       NaN     NaN                 NaN       NaN   \n",
       "77419  2019/6/30 19:09:11       NaN     NaN                 NaN       NaN   \n",
       "77420  2019/6/30 20:12:05       NaN     NaN                 NaN       NaN   \n",
       "77421  2019/6/30 21:46:10       NaN     NaN                 NaN       NaN   \n",
       "\n",
       "      STATUS5        REPAY_TIME5   SEASON6 STATUS6         REPAY_TIME6  \\\n",
       "0         NaN                NaN  201906.0   CLEAR    2019/6/6 4:53:19   \n",
       "1       CLEAR   2019/5/3 9:00:46  201906.0   CLEAR   2019/6/8 11:30:34   \n",
       "2       CLEAR   2019/5/2 9:02:35  201906.0   CLEAR    2019/6/1 8:58:42   \n",
       "3       CLEAR   2019/5/8 9:46:34  201906.0   CLEAR   2019/6/8 11:30:36   \n",
       "4       CLEAR   2019/5/8 9:46:34  201906.0   CLEAR   2019/6/8 11:30:36   \n",
       "5       CLEAR   2019/5/8 9:46:39  201906.0   CLEAR   2019/6/7 21:35:30   \n",
       "6       CLEAR   2019/5/5 9:43:34  201906.0   CLEAR    2019/6/5 8:48:14   \n",
       "7       CLEAR  2019/5/4 16:05:22  201906.0   CLEAR    2019/6/4 9:26:06   \n",
       "8       CLEAR   2019/5/8 9:46:46  201906.0   CLEAR   2019/6/8 11:30:50   \n",
       "9       CLEAR   2019/5/6 9:20:11  201906.0   CLEAR    2019/6/6 9:05:07   \n",
       "10      CLEAR  2019/5/12 9:15:32  201906.0   CLEAR   2019/6/8 11:30:51   \n",
       "11      CLEAR   2019/5/8 9:46:48  201906.0   CLEAR   2019/6/8 11:30:52   \n",
       "12      CLEAR   2019/5/8 9:46:48  201906.0   CLEAR   2019/6/8 11:30:52   \n",
       "13      CLEAR   2019/5/8 9:46:47  201906.0   CLEAR   2019/6/8 11:30:51   \n",
       "14      CLEAR   2019/5/8 9:46:47  201906.0   CLEAR   2019/6/8 11:30:52   \n",
       "15      CLEAR   2019/5/8 9:46:56  201906.0   CLEAR  2019/6/17 11:39:26   \n",
       "16      CLEAR   2019/5/8 9:46:53  201906.0   CLEAR   2019/6/7 21:10:13   \n",
       "17      CLEAR   2019/5/8 9:46:54  201906.0    OPEN                 NaN   \n",
       "18      CLEAR   2019/5/8 9:46:56  201906.0   CLEAR   2019/6/8 11:30:59   \n",
       "19      CLEAR   2019/5/8 9:46:55  201906.0   CLEAR   2019/6/8 11:30:59   \n",
       "20      CLEAR   2019/5/8 9:46:55  201906.0   CLEAR   2019/6/8 11:31:00   \n",
       "21      CLEAR   2019/5/8 9:46:55  201906.0   CLEAR   2019/6/9 20:23:59   \n",
       "22      CLEAR  2019/5/8 20:19:13  201906.0   CLEAR   2019/6/8 11:31:10   \n",
       "23      CLEAR   2019/5/8 9:47:02  201906.0   CLEAR   2019/6/8 11:31:08   \n",
       "24      CLEAR   2019/5/5 9:08:19  201906.0   CLEAR    2019/6/5 9:35:40   \n",
       "25      CLEAR   2019/5/8 9:47:14  201906.0   CLEAR   2019/6/8 11:31:20   \n",
       "26      CLEAR   2019/5/2 9:35:04  201906.0   CLEAR    2019/6/1 9:23:53   \n",
       "27      CLEAR   2019/5/5 9:05:18  201906.0   CLEAR    2019/6/5 9:30:16   \n",
       "28      CLEAR   2019/5/8 9:47:11  201906.0   CLEAR   2019/6/8 11:31:18   \n",
       "29      CLEAR   2019/5/6 9:19:02  201906.0   CLEAR    2019/6/6 9:00:21   \n",
       "...       ...                ...       ...     ...                 ...   \n",
       "77392     NaN                NaN       NaN     NaN                 NaN   \n",
       "77393     NaN                NaN       NaN     NaN                 NaN   \n",
       "77394     NaN                NaN       NaN     NaN                 NaN   \n",
       "77395     NaN                NaN       NaN     NaN                 NaN   \n",
       "77396     NaN                NaN       NaN     NaN                 NaN   \n",
       "77397     NaN                NaN       NaN     NaN                 NaN   \n",
       "77398     NaN                NaN       NaN     NaN                 NaN   \n",
       "77399     NaN                NaN       NaN     NaN                 NaN   \n",
       "77400     NaN                NaN       NaN     NaN                 NaN   \n",
       "77401     NaN                NaN       NaN     NaN                 NaN   \n",
       "77402     NaN                NaN       NaN     NaN                 NaN   \n",
       "77403     NaN                NaN       NaN     NaN                 NaN   \n",
       "77404     NaN                NaN       NaN     NaN                 NaN   \n",
       "77405     NaN                NaN       NaN     NaN                 NaN   \n",
       "77406     NaN                NaN       NaN     NaN                 NaN   \n",
       "77407     NaN                NaN       NaN     NaN                 NaN   \n",
       "77408     NaN                NaN       NaN     NaN                 NaN   \n",
       "77409     NaN                NaN       NaN     NaN                 NaN   \n",
       "77410     NaN                NaN       NaN     NaN                 NaN   \n",
       "77411     NaN                NaN       NaN     NaN                 NaN   \n",
       "77412     NaN                NaN       NaN     NaN                 NaN   \n",
       "77413     NaN                NaN       NaN     NaN                 NaN   \n",
       "77414     NaN                NaN       NaN     NaN                 NaN   \n",
       "77415     NaN                NaN       NaN     NaN                 NaN   \n",
       "77416     NaN                NaN       NaN     NaN                 NaN   \n",
       "77417     NaN                NaN       NaN     NaN                 NaN   \n",
       "77418     NaN                NaN       NaN     NaN                 NaN   \n",
       "77419     NaN                NaN       NaN     NaN                 NaN   \n",
       "77420     NaN                NaN       NaN     NaN                 NaN   \n",
       "77421     NaN                NaN       NaN     NaN                 NaN   \n",
       "\n",
       "       SEASON7 STATUS7         REPAY_TIME7  \n",
       "0       201907   CLEAR   2019/7/6 15:28:18  \n",
       "1       201907   CLEAR   2019/7/4 10:22:52  \n",
       "2       201907   CLEAR    2019/7/1 9:01:47  \n",
       "3       201907   CLEAR   2019/7/8 10:17:21  \n",
       "4       201907    OPEN                 NaN  \n",
       "5       201907   CLEAR    2019/7/3 9:43:59  \n",
       "6       201907   CLEAR    2019/7/8 8:46:29  \n",
       "7       201907   CLEAR   2019/7/4 10:49:49  \n",
       "8       201907   CLEAR   2019/7/8 10:17:29  \n",
       "9       201907   CLEAR    2019/7/6 9:09:52  \n",
       "10      201907   CLEAR    2019/7/4 9:16:19  \n",
       "11      201907   CLEAR   2019/7/8 10:17:31  \n",
       "12      201907   CLEAR   2019/7/8 10:17:30  \n",
       "13      201907   CLEAR   2019/7/8 10:17:30  \n",
       "14      201907   CLEAR    2019/7/7 8:47:35  \n",
       "15      201907   CLEAR   2019/7/11 8:30:52  \n",
       "16      201907   CLEAR    2019/7/3 9:34:39  \n",
       "17      201907    OPEN                 NaN  \n",
       "18      201907   CLEAR   2019/7/8 10:17:34  \n",
       "19      201907   CLEAR   2019/7/8 10:17:33  \n",
       "20      201907   CLEAR   2019/7/8 10:17:34  \n",
       "21      201907   CLEAR   2019/7/8 20:17:31  \n",
       "22      201907   CLEAR   2019/7/8 10:17:37  \n",
       "23      201907   CLEAR   2019/7/8 10:17:37  \n",
       "24      201907   CLEAR   2019/7/8 10:17:39  \n",
       "25      201907   CLEAR    2019/7/8 8:48:48  \n",
       "26      201907   CLEAR    2019/7/1 9:28:50  \n",
       "27      201907   CLEAR    2019/7/8 8:51:40  \n",
       "28      201907   CLEAR   2019/7/8 10:17:42  \n",
       "29      201907   CLEAR    2019/7/6 9:03:13  \n",
       "...        ...     ...                 ...  \n",
       "77392   201907   CLEAR  2019/6/29 19:38:01  \n",
       "77393   201907   CLEAR    2019/7/3 7:39:09  \n",
       "77394   201907   CLEAR   2019/7/8 12:16:33  \n",
       "77395   201907   CLEAR   2019/7/8 12:16:35  \n",
       "77396   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77397   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77398   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77399   201907   CLEAR    2019/7/7 9:08:08  \n",
       "77400   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77401   201907   CLEAR   2019/7/8 12:16:33  \n",
       "77402   201907   CLEAR    2019/7/3 7:59:06  \n",
       "77403   201907   CLEAR    2019/7/6 9:00:47  \n",
       "77404   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77405   201907   CLEAR    2019/7/3 8:03:19  \n",
       "77406   201907   CLEAR   2019/7/3 21:22:56  \n",
       "77407   201907   CLEAR    2019/7/9 9:32:09  \n",
       "77408   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77409   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77410   201907   CLEAR    2019/7/3 8:01:52  \n",
       "77411   201907   CLEAR   2019/7/3 10:13:12  \n",
       "77412   201907   CLEAR   2019/7/5 10:28:26  \n",
       "77413   201907   CLEAR   2019/7/8 12:16:35  \n",
       "77414   201907   CLEAR   2019/7/8 12:16:33  \n",
       "77415   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77416   201907   CLEAR   2019/7/8 12:16:33  \n",
       "77417   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77418   201907   CLEAR   2019/7/8 12:16:35  \n",
       "77419   201907   CLEAR   2019/7/3 22:06:24  \n",
       "77420   201907   CLEAR   2019/7/8 12:16:34  \n",
       "77421   201907   CLEAR   2019/7/8 12:16:34  \n",
       "\n",
       "[77422 rows x 17 columns]"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "\n",
    "# 指定工作目录路径\n",
    "os.chdir('D:\\迁移率')\n",
    "data = pd.read_csv('qianyilv_0711.csv',low_memory=False)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-12T09:24:22.972388Z",
     "start_time": "2019-07-12T09:24:16.275291Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "迁移率数据写入完成！文件位置:D:\\迁移率\n"
     ]
    }
   ],
   "source": [
    "grant=['ZHONGAN','ZHAOLIAN','MASHANGXIAOJIN','WEIXIN','ZIZHUSHOUXIN','BESTPAY','GUOFU','DUMIAO','FENQICHAOREN','ZIYING']\n",
    "user =[1,2,3,4,5]\n",
    "area =['广东省','江苏省','重庆市']\n",
    "\n",
    "for i in grant:\n",
    "    for j in user:\n",
    "        for k in area:\n",
    "            all = data.loc[(data['CREDIT_BY']==i)&(data['USER_TYPE']==j)&(data['ACCEPT_AREA_NAME']==k)].copy()\n",
    "            if all.shape[0] == 0:\n",
    "                pass\n",
    "            else:\n",
    "#                 print(all.shape)\n",
    "                               \n",
    "                \n",
    "                # 转换时间\n",
    "                all['REPAY_TIME4']=pd.to_datetime(all.REPAY_TIME4,format='%Y-%m-%d')\n",
    "                all['REPAY_TIME5']=pd.to_datetime(all.REPAY_TIME5,format='%Y-%m-%d')\n",
    "                all['REPAY_TIME6']=pd.to_datetime(all.REPAY_TIME6,format='%Y-%m-%d')\n",
    "                all['REPAY_TIME7']=pd.to_datetime(all.REPAY_TIME7,format='%Y-%m-%d')\n",
    "                all['COMPLETE_TIME']=pd.to_datetime(all.COMPLETE_TIME,format='%Y-%m-%d').dt.month\n",
    "                # 按完成时间分类\n",
    "                m3 = all[all['COMPLETE_TIME']==3]\n",
    "                m4 = all[all['COMPLETE_TIME']==4]\n",
    "                m5 = all[all['COMPLETE_TIME']==5]\n",
    "                m6 = all[all['COMPLETE_TIME']==6]\n",
    "                m7 = all[all['COMPLETE_TIME']==7]\n",
    "                #4月\n",
    "                #按mob分类\n",
    "                #3月完成\n",
    "                list_m3_t_4 = list(m3[m3['STATUS4']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m3_m1_4 = list(m3[m3['REPAY_TIME4']>='2019-05-01']['ACCOUNT_ID'])+list(m3[m3['STATUS4']=='OPEN']['ACCOUNT_ID'])\n",
    "                list_m3_c_4 = list(set(m3['ACCOUNT_ID']) ^ set(list_m3_t_4 + list_m3_m1_4))\n",
    "\n",
    "                list_all_t_4 = list_m3_t_4\n",
    "                list_all_m1_4 = list_m3_m1_4\n",
    "                list_all_c_4 = list_m3_c_4 + list(m4['ACCOUNT_ID'])\n",
    "                #5月\n",
    "                #按mob分类\n",
    "                #3月完成\n",
    "                list_m3_t_5  = list(m3[m3['STATUS5']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m3_m1_5 = list(m3[(m3['STATUS5']=='OPEN') & (m3['STATUS4']!='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME5']>='2019-06-01') & (m3['REPAY_TIME4']<'2019-06-01')]['ACCOUNT_ID'])\n",
    "                list_m3_m2_5 = list(m3[(m3['STATUS5']=='OPEN') & (m3['STATUS4']=='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME5']>='2019-06-01') & (m3['REPAY_TIME4']>='2019-06-01')]['ACCOUNT_ID'])\n",
    "                list_m3_c_5  = list(set(m3['ACCOUNT_ID']) ^ set(list_m3_t_5 + list_m3_m1_5 + list_m3_m2_5))\n",
    "\n",
    "\n",
    "                #4月完成\n",
    "                list_m4_t_5 = list(m4[m4['STATUS5']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m4_m1_5 = list(m4[m4['STATUS5']=='OPEN']['ACCOUNT_ID']) + list(m4[m4['REPAY_TIME5']>='2019-06-01']['ACCOUNT_ID'])\n",
    "                list_m4_c_5  = list(set(m4['ACCOUNT_ID']) ^ set(list_m4_t_5 + list_m4_m1_5))\n",
    "\n",
    "                #总的\n",
    "                list_all_t_5  = list_m3_t_5 + list_m4_t_5\n",
    "                list_all_m1_5 = list_m3_m1_5 +list_m4_m1_5\n",
    "                list_all_m2_5 = list_m3_m2_5\n",
    "                list_all_c_5  = list_m3_c_5 + list_m4_c_5 + list(m5['ACCOUNT_ID'])\n",
    "\n",
    "                #6月\n",
    "                #按mob分类\n",
    "                #3月完成\n",
    "                list_m3_t_6  = list(m3[m3['STATUS6']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m3_m1_6 = list(m3[(m3['STATUS6']=='OPEN') & (m3['STATUS5']!='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME6']>='2019-07-01') & (m3['REPAY_TIME5']<'2019-07-01')]['ACCOUNT_ID'])\n",
    "                list_m3_m2_6 = list(m3[(m3['STATUS6']=='OPEN') & (m3['STATUS5']=='OPEN') & (m3['STATUS4']!='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME6']>='2019-07-01') & (m3['REPAY_TIME5']>='2019-07-01') & (m3['REPAY_TIME4']<'2019-07-01')]['ACCOUNT_ID'])\n",
    "                list_m3_m3_6 = list(m3[(m3['STATUS6']=='OPEN') & (m3['STATUS5']=='OPEN') & (m3['STATUS4']=='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME6']>='2019-07-01') & (m3['REPAY_TIME5']>='2019-07-01') & (m3['REPAY_TIME4']>='2019-07-01')]['ACCOUNT_ID'])\n",
    "                list_m3_c_6  = list(set(m3['ACCOUNT_ID']) ^ set(list_m3_t_6 + list_m3_m1_6 + list_m3_m2_6 + list_m3_m3_6))\n",
    "\n",
    "                #4月完成\n",
    "                list_m4_t_6 = list(m4[m4['STATUS6']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m4_m1_6 = list(m4[(m4['STATUS6']=='OPEN') & (m4['STATUS5']!='OPEN')]['ACCOUNT_ID']) + list(m4[(m4['REPAY_TIME6']>='2019-07-01') & (m4['REPAY_TIME5']<'2019-07-01')]['ACCOUNT_ID'])\n",
    "                list_m4_m2_6 = list(m4[(m4['STATUS6']=='OPEN') & (m4['STATUS5']=='OPEN')]['ACCOUNT_ID']) + list(m4[(m4['REPAY_TIME6']>='2019-07-01') & (m4['REPAY_TIME5']>='2019-07-01')]['ACCOUNT_ID'])\n",
    "                list_m4_c_6  = list(set(m4['ACCOUNT_ID']) ^ set(list_m4_t_6 + list_m4_m1_6 + list_m4_m2_6))\n",
    "                # 5月\n",
    "                list_m5_t_6  = list(m5[m5['STATUS6']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m5_m1_6 = list(m5[m5['STATUS6']=='OPEN']['ACCOUNT_ID']) + list(m5[m5['REPAY_TIME6']>='2019-07-01']['ACCOUNT_ID'])\n",
    "                list_m5_c_6  = list(set(m5['ACCOUNT_ID']) ^ set(list_m5_t_6 + list_m5_m1_6))\n",
    "\n",
    "                #总的\n",
    "                list_all_t_6  = list_m3_t_6 + list_m4_t_6 + list_m5_t_6\n",
    "                list_all_m1_6 = list_m3_m1_6 + list_m4_m1_6 + list_m5_m1_6\n",
    "                list_all_m2_6 = list_m3_m2_6 + list_m4_m2_6\n",
    "                list_all_m3_6 = list_m3_m3_6\n",
    "                list_all_c_6  = list_m3_c_6 + list_m4_c_6 + list_m5_c_6 + list(m6['ACCOUNT_ID'])\n",
    "                len(list_all_c_6)\n",
    "\n",
    "                #7月\n",
    "                #按mob分类\n",
    "                #3月完成\n",
    "                list_m3_t_7  = list(m3[m3['STATUS7']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m3_m1_7 = list(m3[(m3['STATUS7']=='OPEN') & (m3['STATUS6']!='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME7']>='2019-08-01') & (m3['REPAY_TIME6']<'2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m3_m2_7 = list(m3[(m3['STATUS7']=='OPEN') & (m3['STATUS6']=='OPEN') & (m3['STATUS5']!='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME7']>='2019-08-01') & (m3['REPAY_TIME6']>='2019-08-01') & (m3['REPAY_TIME5']<'2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m3_m3_7 = list(m3[(m3['STATUS7']=='OPEN') & (m3['STATUS6']=='OPEN') & (m3['STATUS5']=='OPEN')&(m3['STATUS4']!='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME7']>='2019-08-01') & (m3['REPAY_TIME6']>='2019-08-01') & (m3['REPAY_TIME5']>='2019-08-01') & (m3['REPAY_TIME4']<'2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m3_m4_7 = list(m3[(m3['STATUS7']=='OPEN') & (m3['STATUS6']=='OPEN') & (m3['STATUS5']=='OPEN')&(m3['STATUS4']=='OPEN')]['ACCOUNT_ID']) + list(m3[(m3['REPAY_TIME7']>='2019-08-01') & (m3['REPAY_TIME6']>='2019-08-01') & (m3['REPAY_TIME5']>='2019-08-01') & (m3['REPAY_TIME4']>='2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m3_c_7  = list(set(m3['ACCOUNT_ID']) ^ set(list_m3_t_7 + list_m3_m1_7 + list_m3_m2_7 + list_m3_m3_7 + list_m3_m4_7))\n",
    "\n",
    "                #4月完成\n",
    "                list_m4_t_7  = list(m4[m4['STATUS7']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m4_m1_7 = list(m4[(m4['STATUS7']=='OPEN') & (m4['STATUS6']!='OPEN')]['ACCOUNT_ID']) + list(m4[(m4['REPAY_TIME7']>='2019-08-01') & (m4['REPAY_TIME6']<'2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m4_m2_7 = list(m4[(m4['STATUS7']=='OPEN') & (m4['STATUS6']=='OPEN') & (m4['STATUS5']!='OPEN')]['ACCOUNT_ID']) + list(m4[(m4['REPAY_TIME7']>='2019-08-01') & (m4['REPAY_TIME6']>='2019-08-01') & (m4['REPAY_TIME5']<'2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m4_m3_7 = list(m4[(m4['STATUS7']=='OPEN') & (m4['STATUS6']=='OPEN') & (m4['STATUS5']=='OPEN')]['ACCOUNT_ID']) + list(m4[(m4['REPAY_TIME7']>='2019-08-01') & (m4['REPAY_TIME6']>='2019-08-01') & (m4['REPAY_TIME5']>='2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m4_c_7  = list(set(m4['ACCOUNT_ID']) ^ set(list_m4_t_7 + list_m4_m1_7 + list_m4_m2_7 + list_m4_m3_7))\n",
    "\n",
    "                #5月完成\n",
    "                list_m5_t_7  = list(m5[m5['STATUS7']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m5_m1_7 = list(m5[(m5['STATUS7']=='OPEN') & (m5['STATUS6']!='OPEN')]['ACCOUNT_ID']) + list(m5[(m5['REPAY_TIME7']>='2019-08-01') & (m5['REPAY_TIME6']<'2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m5_m2_7 = list(m5[(m5['STATUS7']=='OPEN') & (m5['STATUS6']=='OPEN')]['ACCOUNT_ID']) + list(m5[(m5['REPAY_TIME7']>='2019-08-01') & (m5['REPAY_TIME6']>='2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m5_c_7  = list(set(m5['ACCOUNT_ID']) ^ set(list_m5_t_7 + list_m5_m1_7 + list_m5_m2_7))\n",
    "\n",
    "                #6月完成\n",
    "                list_m6_t_7  = list(m6[m6['STATUS7']=='TERMINATE']['ACCOUNT_ID'])\n",
    "                list_m6_m1_7 = list(m6[(m6['STATUS7']=='OPEN')]['ACCOUNT_ID']) + list(m6[(m6['REPAY_TIME7']>='2019-08-01')]['ACCOUNT_ID'])\n",
    "                list_m6_c_7  = list(set(m6['ACCOUNT_ID']) ^ set(list_m6_t_7 + list_m6_m1_7))\n",
    "\n",
    "                #总的\n",
    "                list_all_t_7 = list_m3_t_7 + list_m4_t_7 + list_m5_t_7 + list_m6_t_7\n",
    "                list_all_m1_7 = list_m3_m1_7 + list_m4_m1_7 + list_m5_m1_7 + list_m6_m1_7\n",
    "                list_all_m2_7 = list_m3_m2_7 + list_m4_m2_7 + list_m5_m2_7\n",
    "                list_all_m3_7 = list_m3_m3_7 + list_m4_m3_7\n",
    "                list_all_m4_7 = list_m3_m4_7\n",
    "                list_all_c_7  = list_m3_c_7 + list_m4_c_7 + list_m5_c_7 + list_m6_c_7 + list(m7['ACCOUNT_ID'])\n",
    "\n",
    "\n",
    "                # 计算结果存到dataframe\n",
    "                # C-M1\n",
    "                c_m1_04_z = len(list_all_m1_4)\n",
    "                c_m1_04_m = m3.shape[0]\n",
    "                c_m1_05_z = len(list_all_m1_5)\n",
    "                c_m1_05_m = len(list_all_c_4)\n",
    "                c_m1_06_z = len(list_all_m1_6)\n",
    "                c_m1_06_m = len(list_all_c_5)\n",
    "                c_m1_07_z = len(list_all_m1_7)\n",
    "                c_m1_07_m = len(list_all_c_6)\n",
    "\n",
    "\n",
    "                # M1-M2\n",
    "                m1_m2_05_z = len(list_all_m2_5)\n",
    "                m1_m2_05_m = len(list_all_m1_4)\n",
    "                m1_m2_06_z = len(list_all_m2_6)\n",
    "                m1_m2_06_m = len(list_all_m1_5)\n",
    "                m1_m2_07_z = len(list_all_m2_7)\n",
    "                m1_m2_07_m = len(list_all_m1_6)\n",
    "\n",
    "                # M2-M3\n",
    "                m2_m3_06_z = len(list_all_m3_6)\n",
    "                m2_m3_06_m = len(list_all_m2_5)\n",
    "                m2_m3_07_z = len(list_all_m3_7)\n",
    "                m2_m3_07_m = len(list_all_m2_6)\n",
    "\n",
    "                # M3-M4\n",
    "                m3_m4_07_z = len(list_all_m4_7)\n",
    "                m3_m4_07_m = len(list_all_m3_6)\n",
    "\n",
    "\n",
    "                # C-M2\n",
    "                c_m2_05_z = c_m1_04_z * m1_m2_05_z\n",
    "                c_m2_05_m = c_m1_04_m * m1_m2_05_m\n",
    "                c_m2_06_z = c_m1_05_z * m1_m2_06_z\n",
    "                c_m2_06_m = c_m1_05_m * m1_m2_06_m\n",
    "                c_m2_07_z = c_m1_06_z * m1_m2_07_z\n",
    "                c_m2_07_m = c_m1_06_m * m1_m2_07_m\n",
    "\n",
    "                # C-M3\n",
    "                c_m3_06_z = c_m1_04_z * m1_m2_05_z * m2_m3_06_z\n",
    "                c_m3_06_m = c_m1_04_m * m1_m2_05_m * m2_m3_06_m\n",
    "                c_m3_07_z = c_m1_05_z * m1_m2_06_z * m2_m3_07_z\n",
    "                c_m3_07_m = c_m1_05_m * m1_m2_06_m * m2_m3_07_m\n",
    "\n",
    "                # C-M4\n",
    "                c_m4_07_z = c_m1_04_z * m1_m2_05_z * m2_m3_06_z * m3_m4_07_z\n",
    "                c_m4_07_m = c_m1_04_m * m1_m2_05_m * m2_m3_06_m * m3_m4_07_m\n",
    "\n",
    "\n",
    "                #C-C\n",
    "                c_c_04_z = len(set(list_all_c_4)&set(m3['ACCOUNT_ID']))\n",
    "                c_c_04_m = len(set(m3['ACCOUNT_ID']))\n",
    "                c_c_05_z = len(set(list_all_c_4)&set(list_all_c_5))\n",
    "                c_c_05_m = len(set(list_all_c_4))\n",
    "                c_c_06_z = len(set(list_all_c_6)&set(list_all_c_5))\n",
    "                c_c_06_m = len(set(list_all_c_5))\n",
    "                c_c_07_z = len(set(list_all_c_7)&set(list_all_c_6))\n",
    "                c_c_07_m = len(set(list_all_c_6))\n",
    "                #M1-C\n",
    "                m1_c_05_z = len(set(list_all_m1_4)&set(list_all_c_5))\n",
    "                m1_c_05_m = len(set(list_all_m1_4))\n",
    "                m1_c_06_z = len(set(list_all_m1_5)&set(list_all_c_6))\n",
    "                m1_c_06_m = len(set(list_all_m1_5))\n",
    "                m1_c_07_z = len(set(list_all_m1_6)&set(list_all_c_7))\n",
    "                m1_c_07_m = len(set(list_all_m1_6))\n",
    "                #M2-C\n",
    "                m2_c_06_z = len(set(list_all_m2_5)&set(list_all_c_6))\n",
    "                m2_c_06_m = len(list_all_m2_5)\n",
    "                m2_c_07_z = len(set(list_all_m2_6)&set(list_all_c_7))\n",
    "                m2_c_07_m = len(list_all_m2_6)\n",
    "                # M3-C\n",
    "                m3_c_07_z = len(set(list_all_m3_6)&set(list_all_c_7))\n",
    "                m3_c_07_m = len(list_all_m3_6)\n",
    "                #M1-M1\n",
    "                m1_m1_05_z = len(set(list_all_m1_5)&set(list_all_m1_4))\n",
    "                m1_m1_05_m = len(set(list_all_m1_4))\n",
    "                m1_m1_06_z = len(set(list_all_m1_6)&set(list_all_m1_5))\n",
    "                m1_m1_06_m = len(set(list_all_m1_5))\n",
    "                m1_m1_07_z = len(set(list_all_m1_7)&set(list_all_m1_6))\n",
    "                m1_m1_07_m = len(set(list_all_m1_6))\n",
    "\n",
    "                #M2-M1\n",
    "                m2_m1_06_z = len(set(list_all_m2_5)&set(list_all_m1_6))\n",
    "                m2_m1_06_m = len(set(list_all_m2_5))\n",
    "                m2_m1_07_z = len(set(list_all_m2_6)&set(list_all_m1_7))\n",
    "                m2_m1_07_m = len(set(list_all_m2_6))\n",
    "\n",
    "                # M3-M1\n",
    "                m3_m1_07_z = len(set(list_all_m3_6)&set(list_all_m1_7))\n",
    "                m3_m1_07_m = len(list_all_m3_6)\n",
    "                \n",
    "                # 数据写入到文件\n",
    "                with open('迁移率导出.txt', 'a+') as f:\n",
    "                    # C-M1\n",
    "                    c_m1_4 = \"{},{},{},C-M1,201904,{},{}\".format(i,j,k,c_m1_04_z,c_m1_04_m)\n",
    "                    c_m1_5 = \"{},{},{},C-M1,201905,{},{}\".format(i,j,k,c_m1_05_z,c_m1_05_m)\n",
    "                    c_m1_6 = \"{},{},{},C-M1,201906,{},{}\".format(i,j,k,c_m1_06_z,c_m1_06_m)\n",
    "                    c_m1_7 = \"{},{},{},C-M1,201907,{},{}\".format(i,j,k,c_m1_07_z,c_m1_07_m)\n",
    "                    f.write(c_m1_4+'\\n'+c_m1_5+'\\n'+c_m1_6+'\\n'+c_m1_7+'\\n')\n",
    "                    \n",
    "                    # M1-M2\n",
    "                    m1_m2_5 = \"{},{},{},M1-M2,201905,{},{}\".format(i,j,k,m1_m2_05_z,m1_m2_05_m)\n",
    "                    m1_m2_6 = \"{},{},{},M1-M2,201906,{},{}\".format(i,j,k,m1_m2_06_z,m1_m2_06_m)\n",
    "                    m1_m2_7 = \"{},{},{},M1-M2,201907,{},{}\".format(i,j,k,m1_m2_07_z,m1_m2_07_m)\n",
    "\n",
    "                    f.write(m1_m2_5+'\\n'+m1_m2_6+'\\n'+m1_m2_7+'\\n')\n",
    "                    \n",
    "                    # M2-M3\n",
    "                    m2_m3_6 = \"{},{},{},M2-M3,201906,{},{}\".format(i,j,k,m2_m3_06_z,m2_m3_06_m)\n",
    "                    m2_m3_7 = \"{},{},{},M2-M3,201907,{},{}\".format(i,j,k,m2_m3_07_z,m2_m3_07_m)\n",
    "                    \n",
    "                    f.write(m2_m3_6+'\\n'+m2_m3_7+'\\n')\n",
    "                     \n",
    "                    # M3-M4\n",
    "                    m3_m4_7 = \"{},{},{},M3-M4,201907,{},{}\".format(i,j,k,m3_m4_07_z,m3_m4_07_m)\n",
    "                    \n",
    "                    f.write(m3_m4_7+'\\n')\n",
    "                    \n",
    "                    # C-M2\n",
    "                    c_m2_5 = \"{},{},{},C-M2,201905,{},{}\".format(i,j,k,c_m2_05_z,c_m2_05_m)\n",
    "                    c_m2_6 = \"{},{},{},C-M2,201906,{},{}\".format(i,j,k,c_m2_06_z,c_m2_06_m)\n",
    "                    c_m2_7 = \"{},{},{},C-M2,201907,{},{}\".format(i,j,k,c_m2_07_z,c_m2_07_m)\n",
    "\n",
    "                    f.write(c_m2_5+'\\n'+c_m2_6+'\\n'+c_m2_7+'\\n')\n",
    "                    \n",
    "                    # C-M3\n",
    "                    c_m3_6 = \"{},{},{},C-M3,201906,{},{}\".format(i,j,k,c_m3_06_z,c_m3_06_m)\n",
    "                    c_m3_7 = \"{},{},{},C-M3,201907,{},{}\".format(i,j,k,c_m3_07_z,c_m3_07_m)\n",
    "                    \n",
    "                    f.write(c_m3_6+'\\n'+c_m3_7+'\\n')\n",
    "                    \n",
    "                    # C-M4\n",
    "                    c_m4_7 = \"{},{},{},C-M4,201907,{},{}\".format(i,j,k,c_m4_07_z,c_m4_07_m)\n",
    "                    \n",
    "                    f.write(c_m4_7+'\\n')\n",
    "                    \n",
    "                    # C-C\n",
    "                    c_c_4 = \"{},{},{},C-C,201904,{},{}\".format(i,j,k,c_c_04_z,c_c_04_m)\n",
    "                    c_c_5 = \"{},{},{},C-C,201905,{},{}\".format(i,j,k,c_c_05_z,c_c_05_m)\n",
    "                    c_c_6 = \"{},{},{},C-C,201906,{},{}\".format(i,j,k,c_c_06_z,c_c_06_m)\n",
    "                    c_c_7 = \"{},{},{},C-C,201907,{},{}\".format(i,j,k,c_c_07_z,c_c_07_m)\n",
    "                    f.write(c_c_4+'\\n'+c_c_5+'\\n'+c_c_6+'\\n'+c_c_7+'\\n')\n",
    "                    \n",
    "                    # M1-C\n",
    "                    m1_c_5 = \"{},{},{},M1-C,201905,{},{}\".format(i,j,k,m1_c_05_z,m1_c_05_m)\n",
    "                    m1_c_6 = \"{},{},{},M1-C,201906,{},{}\".format(i,j,k,m1_c_06_z,m1_c_06_m)\n",
    "                    m1_c_7 = \"{},{},{},M1-C,201907,{},{}\".format(i,j,k,m1_c_07_z,m1_c_07_m)\n",
    "\n",
    "                    f.write(m1_c_5+'\\n'+m1_c_6+'\\n'+m1_c_7+'\\n')\n",
    "\n",
    "                    # M2-C\n",
    "                    m2_c_6 = \"{},{},{},M2-C,201906,{},{}\".format(i,j,k,m2_c_06_z,m2_c_06_m)\n",
    "                    m2_c_7 = \"{},{},{},M2-C,201907,{},{}\".format(i,j,k,m2_c_07_z,m2_c_07_m)\n",
    "                    \n",
    "                    f.write(m2_c_6+'\\n'+m2_c_7+'\\n')\n",
    "                     \n",
    "                    # M3-C\n",
    "                    m3_c_7 = \"{},{},{},M3-C,201907,{},{}\".format(i,j,k,m3_c_07_z,m3_c_07_m)\n",
    "                    \n",
    "                    f.write(m3_c_7+'\\n')\n",
    "                    \n",
    "                    # M1-M1\n",
    "                    m1_m1_5 = \"{},{},{},M1-M1,201905,{},{}\".format(i,j,k,m1_m1_05_z,m1_m1_05_m)\n",
    "                    m1_m1_6 = \"{},{},{},M1-M1,201906,{},{}\".format(i,j,k,m1_m1_06_z,m1_m1_06_m)\n",
    "                    m1_m1_7 = \"{},{},{},M1-M1,201907,{},{}\".format(i,j,k,m1_m1_07_z,m1_m1_07_m)\n",
    "\n",
    "                    f.write(m1_m1_5+'\\n'+m1_m1_6+'\\n'+m1_m1_7+'\\n')\n",
    "\n",
    "                    # M2-M1\n",
    "                    m2_m1_6 = \"{},{},{},M2-M1,201906,{},{}\".format(i,j,k,m2_m1_06_z,m2_m1_06_m)\n",
    "                    m2_m1_7 = \"{},{},{},M2-M1,201907,{},{}\".format(i,j,k,m2_m1_07_z,m2_m1_07_m)\n",
    "\n",
    "                    f.write(m2_m1_6+'\\n'+m2_m1_7+'\\n')\n",
    "\n",
    "                    # M3-M1\n",
    "                    m3_m1_7 = \"{},{},{},M3-M1,201907,{},{}\".format(i,j,k,m3_m1_07_z,m3_m1_07_m)\n",
    "\n",
    "                    f.write(m3_m1_7+'\\n')\n",
    "print('迁移率数据写入完成！文件位置:{}'.format(os.getcwd()))\n",
    "                    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
